﻿CREATE TABLE [dbo].[Courses]
(
	[ID] INT NOT NULL PRIMARY KEY IDENTITY, 
    [Name] NVARCHAR(250) NOT NULL, 
    [Description] NVARCHAR(MAX) NOT NULL, 
    [PreReq] NVARCHAR(250) NULL, 
    [DepartmentId] INT NOT NULL, 
    CONSTRAINT [FK_Courses_ToDepartment] FOREIGN KEY ([DepartmentId]) REFERENCES [Department]([Id])
)
